---
title: "SQL-032: Trading-as by sequence number"
summary: Retrieve a trading-as record by trading sequence number.
status: draft
owner: SAIF Corporation
last_reviewed: 2026-08-21
library: SAIF.Business.View.Policy
reference_type: embedded
---

# SQL-032 Trading-as by sequence number

This SQL retrieves a single trading-as record by trading sequence number so the library can load a specific trading-as entity.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-032 |
| **Operation type** | Read |
| **Execution method** | Inline |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsTradingAs` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` / `AfterRetrieve` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:TradingSeqNum` | Input | Decimal | N/A | Trading sequence number identifying the trading-as row to retrieve. |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [TRADING_AS](../database-tables.md#trading_as) | SELECT | `bus_seq_num`, `policy_num`, `trading_seq_num`, `feid_num`, `trading_as_cancel_date`, `trading_as_name`, `uitr_number`, `trading_as_name_eff_date`, `affiliate_ssn`, `create_user`, `create_date`, `update_user`, `update_date`, `registration_date`, `trading_as_type_code` |

## Sample SQL

```sql
SELECT
  TRADING_AS.BUS_SEQ_NUM AS BusSeqNum,
  TRADING_AS.POLICY_NUM AS PolicyNum,
  TRADING_AS.TRADING_SEQ_NUM AS TradingSeqNum,
  TRADING_AS.FEID_NUM AS FeidNum,
  TRADING_AS.TRADING_AS_CANCEL_DATE AS TradingASCancelDate,
  TRADING_AS.TRADING_AS_NAME AS TradingASName,
  TRADING_AS.UITR_NUMBER AS UitrNumber,
  TRADING_AS.TRADING_AS_NAME_EFF_DATE AS TradingASNameEffDate,
  TRADING_AS.AFFILIATE_SSN AS AffiliateSsn,
  TRADING_AS.CREATE_USER AS CreateUser,
  TRADING_AS.CREATE_DATE AS CreateDate,
  TRADING_AS.UPDATE_USER AS UpdateUser,
  TRADING_AS.UPDATE_DATE AS UpdateDate,
  TRADING_AS.REGISTRATION_DATE AS RegistrationDate,
  TRADING_AS.TRADING_AS_TYPE_CODE AS TradingASTypeCode
FROM TRADING_AS
WHERE TRADING_AS.TRADING_SEQ_NUM = :TradingSeqNum
```

## Operations and processes

None.

## Business rules
- [BR-VP-027: Create/Insert/Update/Delete SQL are invalid](../business-rules.md#br-vp-027-createinsertupdatedelete-sql-are-invalid)

## Sources
- `SAIF.Business.View.Policy/clsTradingAs.vb`